Overview
Brought to you by YData
Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 160609 |
| Missing cells | 1202395 |
| Missing cells (%) | 25.8% |
| Duplicate rows | 1003 |
| Duplicate rows (%) | 0.6% |
| Total size in memory | 165.8 MiB |
| Average record size in memory | 1.1 KiB |
Variable types
| DateTime | 4 |
|---|---|
| Categorical | 12 |
| Numeric | 9 |
| Text | 4 |
year has constant value "2024" | Constant |
Cancelled Rides by Customer has constant value "1.0" | Constant |
Cancelled Rides by Driver has constant value "1.0" | Constant |
Incomplete Rides has constant value "1.0" | Constant |
| Dataset has 1003 (0.6%) duplicate rows | Duplicates |
Booking Status is highly overall correlated with Customer Rating and 4 other fields | High correlation |
Customer Rating is highly overall correlated with Booking Status | High correlation |
Driver Cancellation Reason is highly overall correlated with Booking Status | High correlation |
Driver Ratings is highly overall correlated with Booking Status | High correlation |
Incomplete Rides Reason is highly overall correlated with Booking Status | High correlation |
Reason for cancelling by Customer is highly overall correlated with Booking Status | High correlation |
Ride Distance has 51280 (31.9%) missing values | Missing |
Booking Value has 51280 (31.9%) missing values | Missing |
Avg VTAT has 11207 (7.0%) missing values | Missing |
Avg CTAT has 51280 (31.9%) missing values | Missing |
Cancelled Rides by Customer has 149355 (93.0%) missing values | Missing |
Reason for cancelling by Customer has 149355 (93.0%) missing values | Missing |
Cancelled Rides by Driver has 131790 (82.1%) missing values | Missing |
Driver Cancellation Reason has 131790 (82.1%) missing values | Missing |
Incomplete Rides has 150946 (94.0%) missing values | Missing |
Incomplete Rides Reason has 150946 (94.0%) missing values | Missing |
Driver Ratings has 60943 (37.9%) missing values | Missing |
Customer Rating has 60943 (37.9%) missing values | Missing |
Payment Method has 51280 (31.9%) missing values | Missing |
Reproduction
| Analysis started | 2026-01-29 05:50:44.531106 |
|---|---|
| Analysis finished | 2026-01-29 05:51:35.135569 |
| Duration | 50.6 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
datetime
Date
| Distinct | 149532 |
|---|---|
| Distinct (%) | 93.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Minimum | 2024-01-01 00:19:34 |
|---|---|
| Maximum | 2024-12-30 23:36:11 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Date
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Time
Date
| Distinct | 62910 |
|---|---|
| Distinct (%) | 39.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Minimum | 2026-01-29 00:00:00 |
|---|---|
| Maximum | 2026-01-29 23:59:59 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
year
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.3 MiB |
| 2024 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024 |
|---|---|
| 2nd row | 2024 |
| 3rd row | 2024 |
| 4th row | 2024 |
| 5th row | 2024 |
Common Values
| Value | Count | Frequency (%) |
| 2024 | 160609 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024 | 160609 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 321218 | |
| 0 | 160609 | |
| 4 | 160609 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 642436 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 321218 | |
| 0 | 160609 | |
| 4 | 160609 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 642436 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 321218 | |
| 0 | 160609 | |
| 4 | 160609 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 642436 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 321218 | |
| 0 | 160609 | |
| 4 | 160609 |
month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.548232 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.3693271 |
|---|---|
| Coefficient of variation (CV) | 0.51453996 |
| Kurtosis | -1.1423814 |
| Mean | 6.548232 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.040028967 |
| Sum | 1051705 |
| Variance | 11.352365 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 19323 | |
| 10 | 14861 | |
| 8 | 13102 | |
| 4 | 13092 | |
| 1 | 12933 | |
| 5 | 12844 | |
| 3 | 12791 | |
| 6 | 12540 | |
| 11 | 12450 | |
| 12 | 12332 | |
| Other values (2) | 24341 |
| Value | Count | Frequency (%) |
| 1 | 12933 | |
| 2 | 12017 | |
| 3 | 12791 | |
| 4 | 13092 | |
| 5 | 12844 | |
| 6 | 12540 | |
| 7 | 19323 | |
| 8 | 13102 | |
| 9 | 12324 | |
| 10 | 14861 |
| Value | Count | Frequency (%) |
| 12 | 12332 | |
| 11 | 12450 | |
| 10 | 14861 | |
| 9 | 12324 | |
| 8 | 13102 | |
| 7 | 19323 | |
| 6 | 12540 | |
| 5 | 12844 | |
| 4 | 13092 | |
| 3 | 12791 |
day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.175955 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 15 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7790546 |
|---|---|
| Coefficient of variation (CV) | 0.57848448 |
| Kurtosis | -1.1882037 |
| Mean | 15.175955 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.090717827 |
| Sum | 2437395 |
| Variance | 77.071799 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 5922 | 3.7% |
| 4 | 5908 | 3.7% |
| 3 | 5870 | 3.7% |
| 12 | 5842 | 3.6% |
| 2 | 5770 | 3.6% |
| 10 | 5754 | 3.6% |
| 11 | 5736 | 3.6% |
| 15 | 5725 | 3.6% |
| 6 | 5500 | 3.4% |
| 1 | 5491 | 3.4% |
| Other values (21) | 103091 |
| Value | Count | Frequency (%) |
| 1 | 5491 | |
| 2 | 5770 | |
| 3 | 5870 | |
| 4 | 5908 | |
| 5 | 5922 | |
| 6 | 5500 | |
| 7 | 5343 | |
| 8 | 5382 | |
| 9 | 5481 | |
| 10 | 5754 |
| Value | Count | Frequency (%) |
| 31 | 2405 | |
| 30 | 4466 | |
| 29 | 4890 | |
| 28 | 4864 | |
| 27 | 4901 | |
| 26 | 5035 | |
| 25 | 4927 | |
| 24 | 4981 | |
| 23 | 4866 | |
| 22 | 5012 |
weekday
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.8 MiB |
| Saturday | |
|---|---|
| Thursday | |
| Wednesday | |
| Monday | |
| Friday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.1568218 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Saturday |
|---|---|
| 2nd row | Friday |
| 3rd row | Friday |
| 4th row | Monday |
| 5th row | Monday |
Common Values
| Value | Count | Frequency (%) |
| Saturday | 23413 | |
| Thursday | 23411 | |
| Wednesday | 23264 | |
| Monday | 23026 | |
| Friday | 22780 | |
| Sunday | 22359 | |
| Tuesday | 22356 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| saturday | 23413 | |
| thursday | 23411 | |
| wednesday | 23264 | |
| monday | 23026 | |
| friday | 22780 | |
| sunday | 22359 | |
| tuesday | 22356 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 184022 | |
| d | 183873 | |
| y | 160609 | |
| u | 91539 | |
| r | 69604 | 6.1% |
| s | 69031 | 6.0% |
| e | 68884 | 6.0% |
| n | 68649 | 6.0% |
| S | 45772 | 4.0% |
| T | 45767 | 4.0% |
| Other values (7) | 161700 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 988841 | |
| Uppercase Letter | 160609 | 14.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 184022 | |
| d | 183873 | |
| y | 160609 | |
| u | 91539 | |
| r | 69604 | 7.0% |
| s | 69031 | 7.0% |
| e | 68884 | 7.0% |
| n | 68649 | 6.9% |
| t | 23413 | 2.4% |
| h | 23411 | 2.4% |
| Other values (2) | 45806 | 4.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 45772 | |
| T | 45767 | |
| W | 23264 | |
| M | 23026 | |
| F | 22780 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1149450 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 184022 | |
| d | 183873 | |
| y | 160609 | |
| u | 91539 | |
| r | 69604 | 6.1% |
| s | 69031 | 6.0% |
| e | 68884 | 6.0% |
| n | 68649 | 6.0% |
| S | 45772 | 4.0% |
| T | 45767 | 4.0% |
| Other values (7) | 161700 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1149450 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 184022 | |
| d | 183873 | |
| y | 160609 | |
| u | 91539 | |
| r | 69604 | 6.1% |
| s | 69031 | 6.0% |
| e | 68884 | 6.0% |
| n | 68649 | 6.0% |
| S | 45772 | 4.0% |
| T | 45767 | 4.0% |
| Other values (7) | 161700 |
hour
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.032302 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 1469 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 10 |
| median | 15 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.4145955 |
|---|---|
| Coefficient of variation (CV) | 0.38586652 |
| Kurtosis | -0.65176385 |
| Mean | 14.032302 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.41504767 |
| Sum | 2253714 |
| Variance | 29.317845 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 13321 | 8.3% |
| 17 | 11859 | 7.4% |
| 19 | 11828 | 7.4% |
| 20 | 10313 | 6.4% |
| 10 | 10292 | 6.4% |
| 16 | 10281 | 6.4% |
| 11 | 8996 | 5.6% |
| 9 | 8828 | 5.5% |
| 15 | 8769 | 5.5% |
| 21 | 8651 | 5.4% |
| Other values (14) | 57471 |
| Value | Count | Frequency (%) |
| 0 | 1469 | 0.9% |
| 1 | 1456 | 0.9% |
| 2 | 1430 | 0.9% |
| 3 | 1472 | 0.9% |
| 4 | 1412 | 0.9% |
| 5 | 2960 | 1.8% |
| 6 | 4486 | |
| 7 | 5817 | |
| 8 | 7357 | |
| 9 | 8828 |
| Value | Count | Frequency (%) |
| 23 | 2954 | 1.8% |
| 22 | 5793 | |
| 21 | 8651 | |
| 20 | 10313 | |
| 19 | 11828 | |
| 18 | 13321 | |
| 17 | 11859 | |
| 16 | 10281 | |
| 15 | 8769 | |
| 14 | 7523 |
ride_date
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Event
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.3 MiB |
| Normal Day | |
|---|---|
| Wedding_Season | |
| Monsoon | |
| Navratri | 6673 |
| Monsoon_Sales | 6318 |
| Other values (11) |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 10.255036 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Normal Day |
|---|---|
| 2nd row | Wedding_Season |
| 3rd row | Monsoon |
| 4th row | Normal Day |
| 5th row | Normal Day |
Common Values
| Value | Count | Frequency (%) |
| Normal Day | 73084 | |
| Wedding_Season | 33173 | |
| Monsoon | 31838 | |
| Navratri | 6673 | 4.2% |
| Monsoon_Sales | 6318 | 3.9% |
| Diwali | 2466 | 1.5% |
| Festive_Sales | 2058 | 1.3% |
| Eid-ul-Adha | 834 | 0.5% |
| Eid-ul-Fitr | 833 | 0.5% |
| Christmas | 796 | 0.5% |
| Other values (6) | 2536 | 1.6% |
Length
| Value | Count | Frequency (%) |
| day | 73940 | |
| normal | 73084 | |
| wedding_season | 33173 | |
| monsoon | 31838 | |
| navratri | 6673 | 2.8% |
| monsoon_sales | 6318 | 2.7% |
| diwali | 2466 | 1.0% |
| festive_sales | 2058 | 0.9% |
| eid-ul-adha | 834 | 0.4% |
| eid-ul-fitr | 833 | 0.4% |
| Other values (9) | 4173 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 221106 | |
| a | 208164 | |
| n | 144720 | 8.8% |
| r | 88933 | 5.4% |
| l | 86426 | 5.2% |
| s | 84271 | 5.1% |
| e | 82196 | 5.0% |
| N | 80173 | 4.9% |
| D | 76864 | 4.7% |
| 74781 | 4.5% | |
| Other values (28) | 499417 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1248781 | |
| Uppercase Letter | 278606 | 16.9% |
| Space Separator | 74781 | 4.5% |
| Connector Punctuation | 41549 | 2.5% |
| Dash Punctuation | 3334 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 221106 | |
| a | 208164 | |
| n | 144720 | |
| r | 88933 | |
| l | 86426 | 6.9% |
| s | 84271 | 6.7% |
| e | 82196 | 6.6% |
| y | 74365 | 6.0% |
| m | 73880 | 5.9% |
| d | 70080 | 5.6% |
| Other values (10) | 114640 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 80173 | |
| D | 76864 | |
| S | 41549 | |
| M | 38156 | |
| W | 33173 | |
| F | 2891 | 1.0% |
| E | 1667 | 0.6% |
| A | 834 | 0.3% |
| C | 796 | 0.3% |
| R | 452 | 0.2% |
| Other values (5) | 2051 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 74781 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 41549 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3334 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1527387 | |
| Common | 119664 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 221106 | |
| a | 208164 | |
| n | 144720 | 9.5% |
| r | 88933 | 5.8% |
| l | 86426 | 5.7% |
| s | 84271 | 5.5% |
| e | 82196 | 5.4% |
| N | 80173 | 5.2% |
| D | 76864 | 5.0% |
| y | 74365 | 4.9% |
| Other values (25) | 380169 |
Common
| Value | Count | Frequency (%) |
| 74781 | ||
| _ | 41549 | |
| - | 3334 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1647051 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 221106 | |
| a | 208164 | |
| n | 144720 | 8.8% |
| r | 88933 | 5.4% |
| l | 86426 | 5.2% |
| s | 84271 | 5.1% |
| e | 82196 | 5.0% |
| N | 80173 | 4.9% |
| D | 76864 | 4.7% |
| 74781 | 4.5% | |
| Other values (28) | 499417 |
Booking ID
Text
| Distinct | 148767 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 137241 ? |
|---|---|
| Unique (%) | 85.5% |
Sample
| 1st row | "CNR5884300" |
|---|---|
| 2nd row | "CNR1326809" |
| 3rd row | "CNR8494506" |
| 4th row | "CNR8906825" |
| 5th row | "CNR1950162" |
| Value | Count | Frequency (%) |
| cnr8281555 | 4 | < 0.1% |
| cnr2918341 | 4 | < 0.1% |
| cnr2624320 | 4 | < 0.1% |
| cnr2080548 | 4 | < 0.1% |
| cnr4767660 | 4 | < 0.1% |
| cnr1015148 | 4 | < 0.1% |
| cnr9295320 | 4 | < 0.1% |
| cnr8928908 | 4 | < 0.1% |
| cnr2740651 | 4 | < 0.1% |
| cnr5229368 | 4 | < 0.1% |
| Other values (148757) | 160569 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 321218 | |
| C | 160609 | 8.3% |
| N | 160609 | 8.3% |
| R | 160609 | 8.3% |
| 9 | 114665 | 5.9% |
| 7 | 114387 | 5.9% |
| 4 | 114378 | 5.9% |
| 6 | 114321 | 5.9% |
| 5 | 114258 | 5.9% |
| 2 | 114190 | 5.9% |
| Other values (4) | 438064 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1124263 | |
| Uppercase Letter | 481827 | |
| Other Punctuation | 321218 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 114665 | |
| 7 | 114387 | |
| 4 | 114378 | |
| 6 | 114321 | |
| 5 | 114258 | |
| 2 | 114190 | |
| 1 | 114164 | |
| 8 | 114048 | |
| 3 | 113798 | |
| 0 | 96054 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 160609 | |
| N | 160609 | |
| R | 160609 |
Other Punctuation
| Value | Count | Frequency (%) |
| " | 321218 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1445481 | |
| Latin | 481827 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| " | 321218 | |
| 9 | 114665 | 7.9% |
| 7 | 114387 | 7.9% |
| 4 | 114378 | 7.9% |
| 6 | 114321 | 7.9% |
| 5 | 114258 | 7.9% |
| 2 | 114190 | 7.9% |
| 1 | 114164 | 7.9% |
| 8 | 114048 | 7.9% |
| 3 | 113798 | 7.9% |
Latin
| Value | Count | Frequency (%) |
| C | 160609 | |
| N | 160609 | |
| R | 160609 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1927308 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| " | 321218 | |
| C | 160609 | 8.3% |
| N | 160609 | 8.3% |
| R | 160609 | 8.3% |
| 9 | 114665 | 5.9% |
| 7 | 114387 | 5.9% |
| 4 | 114378 | 5.9% |
| 6 | 114321 | 5.9% |
| 5 | 114258 | 5.9% |
| 2 | 114190 | 5.9% |
| Other values (4) | 438064 |
Booking Status
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
| Completed | |
|---|---|
| Cancelled by Driver | |
| Cancelled by Customer | |
| No Driver Found | |
| Incomplete | 9663 |
Length
| Max length | 21 |
|---|---|
| Median length | 9 |
| Mean length | 12.114041 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Driver Found |
|---|---|
| 2nd row | Incomplete |
| 3rd row | Completed |
| 4th row | Completed |
| 5th row | Completed |
Common Values
| Value | Count | Frequency (%) |
| Completed | 99666 | |
| Cancelled by Driver | 28819 | 17.9% |
| Cancelled by Customer | 11254 | 7.0% |
| No Driver Found | 11207 | 7.0% |
| Incomplete | 9663 | 6.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| completed | 99666 | |
| cancelled | 40073 | |
| by | 40073 | |
| driver | 40026 | |
| customer | 11254 | 4.3% |
| no | 11207 | 4.3% |
| found | 11207 | 4.3% |
| incomplete | 9663 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 350084 | |
| l | 189475 | |
| C | 150993 | 7.8% |
| d | 150946 | 7.8% |
| o | 142997 | 7.3% |
| m | 120583 | 6.2% |
| t | 120583 | 6.2% |
| p | 109329 | 5.6% |
| 102560 | 5.3% | |
| r | 91306 | 4.7% |
| Other values (13) | 416768 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1619968 | |
| Uppercase Letter | 223096 | 11.5% |
| Space Separator | 102560 | 5.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 350084 | |
| l | 189475 | |
| d | 150946 | |
| o | 142997 | |
| m | 120583 | 7.4% |
| t | 120583 | 7.4% |
| p | 109329 | 6.7% |
| r | 91306 | 5.6% |
| n | 60943 | 3.8% |
| c | 49736 | 3.1% |
| Other values (7) | 233986 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 150993 | |
| D | 40026 | 17.9% |
| N | 11207 | 5.0% |
| F | 11207 | 5.0% |
| I | 9663 | 4.3% |
Space Separator
| Value | Count | Frequency (%) |
| 102560 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1843064 | |
| Common | 102560 | 5.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 350084 | |
| l | 189475 | |
| C | 150993 | |
| d | 150946 | |
| o | 142997 | |
| m | 120583 | 6.5% |
| t | 120583 | 6.5% |
| p | 109329 | 5.9% |
| r | 91306 | 5.0% |
| n | 60943 | 3.3% |
| Other values (12) | 355825 |
Common
| Value | Count | Frequency (%) |
| 102560 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1945624 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 350084 | |
| l | 189475 | |
| C | 150993 | 7.8% |
| d | 150946 | 7.8% |
| o | 142997 | 7.3% |
| m | 120583 | 6.2% |
| t | 120583 | 6.2% |
| p | 109329 | 5.6% |
| 102560 | 5.3% | |
| r | 91306 | 4.7% |
| Other values (13) | 416768 |
Customer ID
Text
| Distinct | 148788 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 137264 ? |
|---|---|
| Unique (%) | 85.5% |
Sample
| 1st row | "CID1982111" |
|---|---|
| 2nd row | "CID4604802" |
| 3rd row | "CID9202816" |
| 4th row | "CID2610914" |
| 5th row | "CID9933542" |
| Value | Count | Frequency (%) |
| cid8418985 | 4 | < 0.1% |
| cid9681675 | 4 | < 0.1% |
| cid1044355 | 4 | < 0.1% |
| cid4833362 | 4 | < 0.1% |
| cid5102441 | 4 | < 0.1% |
| cid8253544 | 4 | < 0.1% |
| cid4701042 | 4 | < 0.1% |
| cid8165460 | 4 | < 0.1% |
| cid7303248 | 4 | < 0.1% |
| cid9629712 | 4 | < 0.1% |
| Other values (148778) | 160569 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 321218 | |
| C | 160609 | 8.3% |
| I | 160609 | 8.3% |
| D | 160609 | 8.3% |
| 4 | 114765 | 6.0% |
| 6 | 114587 | 5.9% |
| 1 | 114561 | 5.9% |
| 9 | 114307 | 5.9% |
| 5 | 114020 | 5.9% |
| 7 | 114013 | 5.9% |
| Other values (4) | 438010 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1124263 | |
| Uppercase Letter | 481827 | |
| Other Punctuation | 321218 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 114765 | |
| 6 | 114587 | |
| 1 | 114561 | |
| 9 | 114307 | |
| 5 | 114020 | |
| 7 | 114013 | |
| 3 | 113997 | |
| 8 | 113986 | |
| 2 | 113589 | |
| 0 | 96438 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 160609 | |
| I | 160609 | |
| D | 160609 |
Other Punctuation
| Value | Count | Frequency (%) |
| " | 321218 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1445481 | |
| Latin | 481827 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| " | 321218 | |
| 4 | 114765 | 7.9% |
| 6 | 114587 | 7.9% |
| 1 | 114561 | 7.9% |
| 9 | 114307 | 7.9% |
| 5 | 114020 | 7.9% |
| 7 | 114013 | 7.9% |
| 3 | 113997 | 7.9% |
| 8 | 113986 | 7.9% |
| 2 | 113589 | 7.9% |
Latin
| Value | Count | Frequency (%) |
| C | 160609 | |
| I | 160609 | |
| D | 160609 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1927308 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| " | 321218 | |
| C | 160609 | 8.3% |
| I | 160609 | 8.3% |
| D | 160609 | 8.3% |
| 4 | 114765 | 6.0% |
| 6 | 114587 | 5.9% |
| 1 | 114561 | 5.9% |
| 9 | 114307 | 5.9% |
| 5 | 114020 | 5.9% |
| 7 | 114013 | 5.9% |
| Other values (4) | 438010 |
Vehicle Type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.7 MiB |
| Auto | |
|---|---|
| Go Mini | |
| Go Sedan | |
| Bike | |
| Premier Sedan | |
| Other values (2) |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 6.5683181 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | eBike |
|---|---|
| 2nd row | Go Sedan |
| 3rd row | Auto |
| 4th row | Premier Sedan |
| 5th row | Bike |
Common Values
| Value | Count | Frequency (%) |
| Auto | 40066 | |
| Go Mini | 31873 | |
| Go Sedan | 29042 | |
| Bike | 24108 | |
| Premier Sedan | 19453 | |
| eBike | 11285 | 7.0% |
| Uber XL | 4782 | 3.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| go | 60915 | |
| sedan | 48495 | |
| auto | 40066 | |
| mini | 31873 | |
| bike | 24108 | 9.8% |
| premier | 19453 | 7.9% |
| ebike | 11285 | 4.6% |
| uber | 4782 | 1.9% |
| xl | 4782 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 138861 | |
| i | 118592 | |
| o | 100981 | 9.6% |
| 85150 | 8.1% | |
| n | 80368 | 7.6% |
| G | 60915 | 5.8% |
| d | 48495 | 4.6% |
| a | 48495 | 4.6% |
| S | 48495 | 4.6% |
| r | 43688 | 4.1% |
| Other values (12) | 280891 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 719240 | |
| Uppercase Letter | 250541 | 23.7% |
| Space Separator | 85150 | 8.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 138861 | |
| i | 118592 | |
| o | 100981 | |
| n | 80368 | |
| d | 48495 | 6.7% |
| a | 48495 | 6.7% |
| r | 43688 | 6.1% |
| u | 40066 | 5.6% |
| t | 40066 | 5.6% |
| k | 35393 | 4.9% |
| Other values (2) | 24235 | 3.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 60915 | |
| S | 48495 | |
| A | 40066 | |
| B | 35393 | |
| M | 31873 | |
| P | 19453 | 7.8% |
| U | 4782 | 1.9% |
| X | 4782 | 1.9% |
| L | 4782 | 1.9% |
Space Separator
| Value | Count | Frequency (%) |
| 85150 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 969781 | |
| Common | 85150 | 8.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 138861 | |
| i | 118592 | |
| o | 100981 | |
| n | 80368 | 8.3% |
| G | 60915 | 6.3% |
| d | 48495 | 5.0% |
| a | 48495 | 5.0% |
| S | 48495 | 5.0% |
| r | 43688 | 4.5% |
| u | 40066 | 4.1% |
| Other values (11) | 240825 |
Common
| Value | Count | Frequency (%) |
| 85150 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1054931 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 138861 | |
| i | 118592 | |
| o | 100981 | 9.6% |
| 85150 | 8.1% | |
| n | 80368 | 7.6% |
| G | 60915 | 5.8% |
| d | 48495 | 4.6% |
| a | 48495 | 4.6% |
| S | 48495 | 4.6% |
| r | 43688 | 4.1% |
| Other values (12) | 280891 |
Pickup Location
Text
| Distinct | 176 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.5 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 19 |
| Mean length | 11.504978 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Palam Vihar |
|---|---|
| 2nd row | Shastri Nagar |
| 3rd row | Khandsa |
| 4th row | Central Secretariat |
| 5th row | Ghitorni Village |
| Value | Count | Frequency (%) |
| nagar | 15520 | 5.2% |
| vihar | 9032 | 3.0% |
| chowk | 7376 | 2.5% |
| park | 5593 | 1.9% |
| gurgaon | 5374 | 1.8% |
| sector | 5354 | 1.8% |
| road | 4546 | 1.5% |
| noida | 4507 | 1.5% |
| city | 3734 | 1.3% |
| garden | 3655 | 1.2% |
| Other values (214) | 233229 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 297186 | |
| r | 137624 | 7.4% |
| 137311 | 7.4% | |
| i | 117500 | 6.4% |
| h | 95650 | 5.2% |
| n | 80066 | 4.3% |
| e | 77209 | 4.2% |
| o | 73657 | 4.0% |
| t | 60143 | 3.3% |
| u | 57330 | 3.1% |
| Other values (48) | 714127 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1374375 | |
| Uppercase Letter | 323617 | 17.5% |
| Space Separator | 137311 | 7.4% |
| Decimal Number | 12500 | 0.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 297186 | |
| r | 137624 | |
| i | 117500 | 8.5% |
| h | 95650 | 7.0% |
| n | 80066 | 5.8% |
| e | 77209 | 5.6% |
| o | 73657 | 5.4% |
| t | 60143 | 4.4% |
| u | 57330 | 4.2% |
| d | 55757 | 4.1% |
| Other values (15) | 322253 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 32801 | 10.1% |
| N | 28251 | 8.7% |
| P | 25659 | 7.9% |
| M | 25637 | 7.9% |
| G | 25292 | 7.8% |
| C | 23798 | 7.4% |
| K | 18420 | 5.7% |
| B | 17417 | 5.4% |
| R | 17327 | 5.4% |
| I | 15594 | 4.8% |
| Other values (14) | 93421 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2722 | |
| 1 | 2699 | |
| 5 | 1790 | |
| 6 | 1785 | |
| 3 | 900 | 7.2% |
| 4 | 892 | 7.1% |
| 9 | 870 | 7.0% |
| 8 | 842 | 6.7% |
Space Separator
| Value | Count | Frequency (%) |
| 137311 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1697992 | |
| Common | 149811 | 8.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 297186 | |
| r | 137624 | 8.1% |
| i | 117500 | 6.9% |
| h | 95650 | 5.6% |
| n | 80066 | 4.7% |
| e | 77209 | 4.5% |
| o | 73657 | 4.3% |
| t | 60143 | 3.5% |
| u | 57330 | 3.4% |
| d | 55757 | 3.3% |
| Other values (39) | 645870 |
Common
| Value | Count | Frequency (%) |
| 137311 | ||
| 2 | 2722 | 1.8% |
| 1 | 2699 | 1.8% |
| 5 | 1790 | 1.2% |
| 6 | 1785 | 1.2% |
| 3 | 900 | 0.6% |
| 4 | 892 | 0.6% |
| 9 | 870 | 0.6% |
| 8 | 842 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1847803 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 297186 | |
| r | 137624 | 7.4% |
| 137311 | 7.4% | |
| i | 117500 | 6.4% |
| h | 95650 | 5.2% |
| n | 80066 | 4.3% |
| e | 77209 | 4.2% |
| o | 73657 | 4.0% |
| t | 60143 | 3.3% |
| u | 57330 | 3.1% |
| Other values (48) | 714127 |
Drop Location
Text
| Distinct | 176 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.5 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 20 |
| Mean length | 11.513022 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jhilmil |
|---|---|
| 2nd row | Gurgaon Sector 56 |
| 3rd row | Malviya Nagar |
| 4th row | Inderlok |
| 5th row | Khan Market |
| Value | Count | Frequency (%) |
| nagar | 15590 | 5.2% |
| vihar | 9153 | 3.1% |
| chowk | 7152 | 2.4% |
| sector | 5495 | 1.8% |
| gurgaon | 5474 | 1.8% |
| park | 5377 | 1.8% |
| noida | 4616 | 1.5% |
| road | 4420 | 1.5% |
| gate | 3729 | 1.2% |
| delhi | 3720 | 1.2% |
| Other values (214) | 233661 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 296655 | |
| 137778 | 7.5% | |
| r | 137702 | 7.4% |
| i | 117601 | 6.4% |
| h | 96066 | 5.2% |
| n | 80097 | 4.3% |
| e | 77672 | 4.2% |
| o | 74016 | 4.0% |
| t | 60267 | 3.3% |
| u | 57151 | 3.1% |
| Other values (48) | 714090 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1374931 | |
| Uppercase Letter | 323513 | 17.5% |
| Space Separator | 137778 | 7.5% |
| Decimal Number | 12873 | 0.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 296655 | |
| r | 137702 | |
| i | 117601 | 8.6% |
| h | 96066 | 7.0% |
| n | 80097 | 5.8% |
| e | 77672 | 5.6% |
| o | 74016 | 5.4% |
| t | 60267 | 4.4% |
| u | 57151 | 4.2% |
| d | 55343 | 4.0% |
| Other values (15) | 322361 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 32779 | 10.1% |
| N | 28630 | 8.8% |
| P | 25583 | 7.9% |
| M | 25563 | 7.9% |
| G | 25538 | 7.9% |
| C | 23306 | 7.2% |
| K | 18424 | 5.7% |
| B | 17183 | 5.3% |
| R | 17166 | 5.3% |
| V | 15457 | 4.8% |
| Other values (14) | 93884 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2742 | |
| 2 | 2696 | |
| 5 | 1883 | |
| 6 | 1865 | |
| 3 | 942 | 7.3% |
| 4 | 941 | 7.3% |
| 8 | 916 | 7.1% |
| 9 | 888 | 6.9% |
Space Separator
| Value | Count | Frequency (%) |
| 137778 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1698444 | |
| Common | 150651 | 8.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 296655 | |
| r | 137702 | 8.1% |
| i | 117601 | 6.9% |
| h | 96066 | 5.7% |
| n | 80097 | 4.7% |
| e | 77672 | 4.6% |
| o | 74016 | 4.4% |
| t | 60267 | 3.5% |
| u | 57151 | 3.4% |
| d | 55343 | 3.3% |
| Other values (39) | 645874 |
Common
| Value | Count | Frequency (%) |
| 137778 | ||
| 1 | 2742 | 1.8% |
| 2 | 2696 | 1.8% |
| 5 | 1883 | 1.2% |
| 6 | 1865 | 1.2% |
| 3 | 942 | 0.6% |
| 4 | 941 | 0.6% |
| 8 | 916 | 0.6% |
| 9 | 888 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1849095 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 296655 | |
| 137778 | 7.5% | |
| r | 137702 | 7.4% |
| i | 117601 | 6.4% |
| h | 96066 | 5.2% |
| n | 80097 | 4.3% |
| e | 77672 | 4.2% |
| o | 74016 | 4.0% |
| t | 60267 | 3.3% |
| u | 57151 | 3.1% |
| Other values (48) | 714090 |
Ride Distance
Real number (ℝ)
Missing 
| Distinct | 4901 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 51280 |
| Missing (%) | 31.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.616326 |
| Minimum | 1 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3.97 |
| Q1 | 12.43 |
| median | 23.67 |
| Q3 | 36.79 |
| 95-th percentile | 47.35 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 24.36 |
Descriptive statistics
| Standard deviation | 13.999738 |
|---|---|
| Coefficient of variation (CV) | 0.56871762 |
| Kurtosis | -1.2118066 |
| Mean | 24.616326 |
| Median Absolute Deviation (MAD) | 12.09 |
| Skewness | 0.13028125 |
| Sum | 2691278.3 |
| Variance | 195.99268 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.61 | 47 | < 0.1% |
| 14.93 | 46 | < 0.1% |
| 3.44 | 45 | < 0.1% |
| 17.31 | 44 | < 0.1% |
| 14.47 | 44 | < 0.1% |
| 12.52 | 43 | < 0.1% |
| 12.87 | 43 | < 0.1% |
| 15.02 | 42 | < 0.1% |
| 8.69 | 41 | < 0.1% |
| 8.97 | 41 | < 0.1% |
| Other values (4891) | 108893 | |
| (Missing) | 51280 |
| Value | Count | Frequency (%) |
| 1 | 6 | |
| 1.01 | 3 | < 0.1% |
| 1.02 | 5 | |
| 1.03 | 5 | |
| 1.04 | 3 | < 0.1% |
| 1.05 | 3 | < 0.1% |
| 1.06 | 5 | |
| 1.07 | 8 | |
| 1.08 | 1 | < 0.1% |
| 1.09 | 6 |
| Value | Count | Frequency (%) |
| 50 | 10 | < 0.1% |
| 49.99 | 20 | |
| 49.98 | 22 | |
| 49.97 | 22 | |
| 49.96 | 21 | |
| 49.95 | 17 | |
| 49.94 | 21 | |
| 49.93 | 25 | |
| 49.92 | 17 | |
| 49.91 | 19 |
Booking Value
Real number (ℝ)
Missing 
| Distinct | 2566 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 51280 |
| Missing (%) | 31.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 508.63849 |
| Minimum | 50 |
|---|---|
| Maximum | 4277 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 91 |
| Q1 | 234 |
| median | 414 |
| Q3 | 689 |
| 95-th percentile | 1225 |
| Maximum | 4277 |
| Range | 4227 |
| Interquartile range (IQR) | 455 |
Descriptive statistics
| Standard deviation | 396.31267 |
|---|---|
| Coefficient of variation (CV) | 0.77916373 |
| Kurtosis | 9.9549601 |
| Mean | 508.63849 |
| Median Absolute Deviation (MAD) | 211 |
| Skewness | 2.2955538 |
| Sum | 55608938 |
| Variance | 157063.73 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 186 | 0.1% |
| 176 | 185 | 0.1% |
| 125 | 182 | 0.1% |
| 157 | 181 | 0.1% |
| 470 | 181 | 0.1% |
| 249 | 180 | 0.1% |
| 408 | 180 | 0.1% |
| 240 | 180 | 0.1% |
| 98 | 179 | 0.1% |
| 186 | 178 | 0.1% |
| Other values (2556) | 107517 | |
| (Missing) | 51280 |
| Value | Count | Frequency (%) |
| 50 | 132 | |
| 51 | 113 | |
| 52 | 123 | |
| 53 | 146 | |
| 54 | 103 | |
| 55 | 111 | |
| 56 | 122 | |
| 57 | 120 | |
| 58 | 118 | |
| 59 | 125 |
| Value | Count | Frequency (%) |
| 4277 | 2 | |
| 4228 | 1 | |
| 4220 | 1 | |
| 4202 | 1 | |
| 4133 | 2 | |
| 4109 | 1 | |
| 4093 | 1 | |
| 4088 | 1 | |
| 4060 | 1 | |
| 4044 | 1 |
Avg VTAT
Real number (ℝ)
Missing 
| Distinct | 181 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 11207 |
| Missing (%) | 7.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4521171 |
| Minimum | 2 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2.9 |
| Q1 | 5.3 |
| median | 8.3 |
| Q3 | 11.3 |
| 95-th percentile | 14.6 |
| Maximum | 20 |
| Range | 18 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.7720348 |
|---|---|
| Coefficient of variation (CV) | 0.44628283 |
| Kurtosis | -0.5949816 |
| Mean | 8.4521171 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.30841726 |
| Sum | 1262763.2 |
| Variance | 14.228246 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.4 | 1352 | 0.8% |
| 5.8 | 1348 | 0.8% |
| 6.5 | 1347 | 0.8% |
| 6 | 1340 | 0.8% |
| 9.5 | 1339 | 0.8% |
| 6.2 | 1335 | 0.8% |
| 7.4 | 1323 | 0.8% |
| 7.7 | 1320 | 0.8% |
| 8.9 | 1319 | 0.8% |
| 5.1 | 1315 | 0.8% |
| Other values (171) | 136064 | |
| (Missing) | 11207 | 7.0% |
| Value | Count | Frequency (%) |
| 2 | 436 | |
| 2.1 | 902 | |
| 2.2 | 830 | |
| 2.3 | 843 | |
| 2.4 | 869 | |
| 2.5 | 888 | |
| 2.6 | 878 | |
| 2.7 | 834 | |
| 2.8 | 873 | |
| 2.9 | 884 |
| Value | Count | Frequency (%) |
| 20 | 39 | |
| 19.9 | 93 | |
| 19.8 | 83 | |
| 19.7 | 73 | |
| 19.6 | 79 | |
| 19.5 | 61 | |
| 19.4 | 97 | |
| 19.3 | 64 | |
| 19.2 | 84 | |
| 19.1 | 65 |
Avg CTAT
Real number (ℝ)
Missing 
| Distinct | 351 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 51280 |
| Missing (%) | 31.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.137421 |
| Minimum | 10 |
|---|---|
| Maximum | 45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15.8 |
| Q1 | 21.6 |
| median | 28.7 |
| Q3 | 36.8 |
| 95-th percentile | 43.3 |
| Maximum | 45 |
| Range | 35 |
| Interquartile range (IQR) | 15.2 |
Descriptive statistics
| Standard deviation | 8.9071902 |
|---|---|
| Coefficient of variation (CV) | 0.3056959 |
| Kurtosis | -1.1256407 |
| Mean | 29.137421 |
| Median Absolute Deviation (MAD) | 7.6 |
| Skewness | 0.047091738 |
| Sum | 3185565.1 |
| Variance | 79.338037 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24.8 | 426 | 0.3% |
| 18.5 | 423 | 0.3% |
| 20 | 419 | 0.3% |
| 23.5 | 419 | 0.3% |
| 28.1 | 417 | 0.3% |
| 21.1 | 412 | 0.3% |
| 25.9 | 410 | 0.3% |
| 20.5 | 409 | 0.3% |
| 22.4 | 409 | 0.3% |
| 26.6 | 408 | 0.3% |
| Other values (341) | 105177 | |
| (Missing) | 51280 |
| Value | Count | Frequency (%) |
| 10 | 24 | |
| 10.1 | 53 | |
| 10.2 | 49 | |
| 10.3 | 45 | |
| 10.4 | 54 | |
| 10.5 | 49 | |
| 10.6 | 50 | |
| 10.7 | 50 | |
| 10.8 | 50 | |
| 10.9 | 44 |
| Value | Count | Frequency (%) |
| 45 | 149 | |
| 44.9 | 336 | |
| 44.8 | 333 | |
| 44.7 | 352 | |
| 44.6 | 332 | |
| 44.5 | 318 | |
| 44.4 | 340 | |
| 44.3 | 282 | |
| 44.2 | 320 | |
| 44.1 | 335 |
Cancelled Rides by Customer
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 149355 |
| Missing (%) | 93.0% |
| Memory size | 9.8 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 11254 | 7.0% |
| (Missing) | 149355 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 11254 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 11254 | |
| . | 11254 | |
| 0 | 11254 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 22508 | |
| Other Punctuation | 11254 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 11254 | |
| 0 | 11254 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 11254 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 33762 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 11254 | |
| . | 11254 | |
| 0 | 11254 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33762 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 11254 | |
| . | 11254 | |
| 0 | 11254 |
Reason for cancelling by Customer
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 149355 |
| Missing (%) | 93.0% |
| Memory size | 10.0 MiB |
| Change of plans | |
|---|---|
| Wrong Address | |
| Driver is not moving towards pickup location | |
| Driver asked to cancel | |
| AC is not working |
Length
| Max length | 44 |
|---|---|
| Median length | 17 |
| Mean length | 22.772348 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Driver is not moving towards pickup location |
|---|---|
| 2nd row | Driver is not moving towards pickup location |
| 3rd row | Driver asked to cancel |
| 4th row | Driver is not moving towards pickup location |
| 5th row | Driver asked to cancel |
Common Values
| Value | Count | Frequency (%) |
| Change of plans | 2531 | 1.6% |
| Wrong Address | 2515 | 1.6% |
| Driver is not moving towards pickup location | 2512 | 1.6% |
| Driver asked to cancel | 2452 | 1.5% |
| AC is not working | 1244 | 0.8% |
| (Missing) | 149355 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| driver | 4964 | 11.0% |
| is | 3756 | 8.3% |
| not | 3756 | 8.3% |
| change | 2531 | 5.6% |
| plans | 2531 | 5.6% |
| of | 2531 | 5.6% |
| wrong | 2515 | 5.6% |
| address | 2515 | 5.6% |
| pickup | 2512 | 5.6% |
| location | 2512 | 5.6% |
| Other values (7) | 14868 |
Most occurring characters
| Value | Count | Frequency (%) |
| 33737 | ||
| o | 22546 | 8.8% |
| n | 20053 | 7.8% |
| r | 18714 | 7.3% |
| i | 17500 | 6.8% |
| s | 16281 | 6.4% |
| a | 14990 | 5.8% |
| e | 14914 | 5.8% |
| t | 11232 | 4.4% |
| d | 9994 | 3.9% |
| Other values (15) | 76319 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 207530 | |
| Space Separator | 33737 | 13.2% |
| Uppercase Letter | 15013 | 5.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 22546 | |
| n | 20053 | 9.7% |
| r | 18714 | 9.0% |
| i | 17500 | 8.4% |
| s | 16281 | 7.8% |
| a | 14990 | 7.2% |
| e | 14914 | 7.2% |
| t | 11232 | 5.4% |
| d | 9994 | 4.8% |
| c | 9928 | 4.8% |
| Other values (10) | 51378 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 4964 | |
| C | 3775 | |
| A | 3759 | |
| W | 2515 |
Space Separator
| Value | Count | Frequency (%) |
| 33737 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 222543 | |
| Common | 33737 | 13.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 22546 | 10.1% |
| n | 20053 | 9.0% |
| r | 18714 | 8.4% |
| i | 17500 | 7.9% |
| s | 16281 | 7.3% |
| a | 14990 | 6.7% |
| e | 14914 | 6.7% |
| t | 11232 | 5.0% |
| d | 9994 | 4.5% |
| c | 9928 | 4.5% |
| Other values (14) | 66391 |
Common
| Value | Count | Frequency (%) |
| 33737 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 256280 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 33737 | ||
| o | 22546 | 8.8% |
| n | 20053 | 7.8% |
| r | 18714 | 7.3% |
| i | 17500 | 6.8% |
| s | 16281 | 6.4% |
| a | 14990 | 5.8% |
| e | 14914 | 5.8% |
| t | 11232 | 4.4% |
| d | 9994 | 3.9% |
| Other values (15) | 76319 |
Cancelled Rides by Driver
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 131790 |
| Missing (%) | 82.1% |
| Memory size | 9.7 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 28819 | 17.9% |
| (Missing) | 131790 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 28819 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 28819 | |
| . | 28819 | |
| 0 | 28819 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 57638 | |
| Other Punctuation | 28819 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 28819 | |
| 0 | 28819 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 28819 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86457 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 28819 | |
| . | 28819 | |
| 0 | 28819 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86457 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 28819 | |
| . | 28819 | |
| 0 | 28819 |
Driver Cancellation Reason
Categorical
High correlation  Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 131790 |
| Missing (%) | 82.1% |
| Memory size | 10.4 MiB |
| Customer related issue | |
|---|---|
| The customer was coughing/sick | |
| Personal & Car related issues | |
| More than permitted people in there |
Length
| Max length | 35 |
|---|---|
| Median length | 30 |
| Mean length | 28.970054 |
| Min length | 22 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Personal & Car related issues |
|---|---|
| 2nd row | Customer related issue |
| 3rd row | Customer related issue |
| 4th row | Personal & Car related issues |
| 5th row | More than permitted people in there |
Common Values
| Value | Count | Frequency (%) |
| Customer related issue | 7282 | 4.5% |
| The customer was coughing/sick | 7211 | 4.5% |
| Personal & Car related issues | 7176 | 4.5% |
| More than permitted people in there | 7150 | 4.5% |
| (Missing) | 131790 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| customer | 14493 | 11.2% |
| related | 14458 | 11.2% |
| issue | 7282 | 5.6% |
| the | 7211 | 5.6% |
| was | 7211 | 5.6% |
| coughing/sick | 7211 | 5.6% |
| personal | 7176 | 5.5% |
| 7176 | 5.5% | |
| car | 7176 | 5.5% |
| issues | 7176 | 5.5% |
| Other values (6) | 42900 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 122304 | |
| 100651 | ||
| s | 72183 | 8.6% |
| r | 64753 | 7.8% |
| t | 57551 | 6.9% |
| i | 43180 | 5.2% |
| o | 43180 | 5.2% |
| a | 43171 | 5.2% |
| u | 36162 | 4.3% |
| l | 28784 | 3.4% |
| Other values (15) | 222969 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 683855 | |
| Space Separator | 100651 | 12.1% |
| Uppercase Letter | 35995 | 4.3% |
| Other Punctuation | 14387 | 1.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 122304 | |
| s | 72183 | |
| r | 64753 | |
| t | 57551 | |
| i | 43180 | 6.3% |
| o | 43180 | 6.3% |
| a | 43171 | 6.3% |
| u | 36162 | 5.3% |
| l | 28784 | 4.2% |
| h | 28722 | 4.2% |
| Other values (8) | 143865 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 14458 | |
| T | 7211 | |
| P | 7176 | |
| M | 7150 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 7211 | |
| & | 7176 |
Space Separator
| Value | Count | Frequency (%) |
| 100651 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 719850 | |
| Common | 115038 | 13.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 122304 | |
| s | 72183 | |
| r | 64753 | 9.0% |
| t | 57551 | 8.0% |
| i | 43180 | 6.0% |
| o | 43180 | 6.0% |
| a | 43171 | 6.0% |
| u | 36162 | 5.0% |
| l | 28784 | 4.0% |
| h | 28722 | 4.0% |
| Other values (12) | 179860 |
Common
| Value | Count | Frequency (%) |
| 100651 | ||
| / | 7211 | 6.3% |
| & | 7176 | 6.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 834888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 122304 | |
| 100651 | ||
| s | 72183 | 8.6% |
| r | 64753 | 7.8% |
| t | 57551 | 6.9% |
| i | 43180 | 5.2% |
| o | 43180 | 5.2% |
| a | 43171 | 5.2% |
| u | 36162 | 4.3% |
| l | 28784 | 3.4% |
| Other values (15) | 222969 |
Incomplete Rides
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 150946 |
| Missing (%) | 94.0% |
| Memory size | 9.8 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 9663 | 6.0% |
| (Missing) | 150946 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 9663 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 9663 | |
| . | 9663 | |
| 0 | 9663 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 19326 | |
| Other Punctuation | 9663 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 9663 | |
| 0 | 9663 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 9663 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 28989 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 9663 | |
| . | 9663 | |
| 0 | 9663 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28989 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 9663 | |
| . | 9663 | |
| 0 | 9663 |
Incomplete Rides Reason
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 150946 |
| Missing (%) | 94.0% |
| Memory size | 9.9 MiB |
| Customer Demand | |
|---|---|
| Vehicle Breakdown | |
| Other Issue |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 14.362103 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Vehicle Breakdown |
|---|---|
| 2nd row | Other Issue |
| 3rd row | Vehicle Breakdown |
| 4th row | Other Issue |
| 5th row | Vehicle Breakdown |
Common Values
| Value | Count | Frequency (%) |
| Customer Demand | 3268 | 2.0% |
| Vehicle Breakdown | 3236 | 2.0% |
| Other Issue | 3159 | 2.0% |
| (Missing) | 150946 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| customer | 3268 | |
| demand | 3268 | |
| vehicle | 3236 | |
| breakdown | 3236 | |
| other | 3159 | |
| issue | 3159 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 22562 | |
| r | 9663 | 7.0% |
| 9663 | 7.0% | |
| s | 9586 | 6.9% |
| m | 6536 | 4.7% |
| n | 6504 | 4.7% |
| d | 6504 | 4.7% |
| o | 6504 | 4.7% |
| a | 6504 | 4.7% |
| t | 6427 | 4.6% |
| Other values (13) | 48328 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 109792 | |
| Uppercase Letter | 19326 | 13.9% |
| Space Separator | 9663 | 7.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 22562 | |
| r | 9663 | |
| s | 9586 | |
| m | 6536 | 6.0% |
| n | 6504 | 5.9% |
| d | 6504 | 5.9% |
| o | 6504 | 5.9% |
| a | 6504 | 5.9% |
| t | 6427 | 5.9% |
| u | 6427 | 5.9% |
| Other values (6) | 22575 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 3268 | |
| D | 3268 | |
| V | 3236 | |
| B | 3236 | |
| O | 3159 | |
| I | 3159 |
Space Separator
| Value | Count | Frequency (%) |
| 9663 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 129118 | |
| Common | 9663 | 7.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 22562 | |
| r | 9663 | 7.5% |
| s | 9586 | 7.4% |
| m | 6536 | 5.1% |
| n | 6504 | 5.0% |
| d | 6504 | 5.0% |
| o | 6504 | 5.0% |
| a | 6504 | 5.0% |
| t | 6427 | 5.0% |
| u | 6427 | 5.0% |
| Other values (12) | 41901 |
Common
| Value | Count | Frequency (%) |
| 9663 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 138781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 22562 | |
| r | 9663 | 7.0% |
| 9663 | 7.0% | |
| s | 9586 | 6.9% |
| m | 6536 | 4.7% |
| n | 6504 | 4.7% |
| d | 6504 | 4.7% |
| o | 6504 | 4.7% |
| a | 6504 | 4.7% |
| t | 6427 | 4.6% |
| Other values (13) | 48328 |
Driver Ratings
Real number (ℝ)
High correlation  Missing 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 60943 |
| Missing (%) | 37.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2306825 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.3 |
| Q1 | 4.1 |
| median | 4.3 |
| Q3 | 4.6 |
| 95-th percentile | 4.9 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.43697093 |
|---|---|
| Coefficient of variation (CV) | 0.10328616 |
| Kurtosis | 0.2766847 |
| Mean | 4.2306825 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.6553693 |
| Sum | 421655.2 |
| Variance | 0.19094359 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.3 | 15096 | 9.4% |
| 4.2 | 14845 | 9.2% |
| 4.6 | 10009 | 6.2% |
| 4.4 | 7511 | 4.7% |
| 4.1 | 7453 | 4.6% |
| 4.7 | 5032 | 3.1% |
| 4.9 | 5024 | 3.1% |
| 4.5 | 4989 | 3.1% |
| 3.9 | 4210 | 2.6% |
| 3.8 | 4123 | 2.6% |
| Other values (11) | 21374 | 13.3% |
| (Missing) | 60943 |
| Value | Count | Frequency (%) |
| 3 | 798 | 0.5% |
| 3.1 | 1558 | 1.0% |
| 3.2 | 1652 | 1.0% |
| 3.3 | 1573 | 1.0% |
| 3.4 | 1612 | 1.0% |
| 3.5 | 804 | 0.5% |
| 3.6 | 2185 | |
| 3.7 | 4055 | |
| 3.8 | 4123 | |
| 3.9 | 4210 |
| Value | Count | Frequency (%) |
| 5 | 2532 | 1.6% |
| 4.9 | 5024 | 3.1% |
| 4.8 | 2495 | 1.6% |
| 4.7 | 5032 | 3.1% |
| 4.6 | 10009 | |
| 4.5 | 4989 | 3.1% |
| 4.4 | 7511 | |
| 4.3 | 15096 | |
| 4.2 | 14845 | |
| 4.1 | 7453 |
Customer Rating
Real number (ℝ)
High correlation  Missing 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 60943 |
| Missing (%) | 37.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.404499 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.2 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.6 |
| Q1 | 4.2 |
| median | 4.5 |
| Q3 | 4.8 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 0.6 |
Descriptive statistics
| Standard deviation | 0.43777579 |
|---|---|
| Coefficient of variation (CV) | 0.099392869 |
| Kurtosis | 0.64585631 |
| Mean | 4.404499 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.88417172 |
| Sum | 438978.8 |
| Variance | 0.19164765 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.9 | 12463 | 7.8% |
| 4.6 | 12395 | 7.7% |
| 4.3 | 11812 | 7.4% |
| 4.2 | 11468 | 7.1% |
| 4.8 | 6306 | 3.9% |
| 4.5 | 6278 | 3.9% |
| 5 | 6267 | 3.9% |
| 4.7 | 6149 | 3.8% |
| 4.1 | 5802 | 3.6% |
| 4.4 | 5628 | 3.5% |
| Other values (11) | 15098 | 9.4% |
| (Missing) | 60943 |
| Value | Count | Frequency (%) |
| 3 | 500 | 0.3% |
| 3.1 | 1083 | |
| 3.2 | 938 | 0.6% |
| 3.3 | 961 | 0.6% |
| 3.4 | 1003 | 0.6% |
| 3.5 | 474 | 0.3% |
| 3.6 | 1263 | |
| 3.7 | 2533 | |
| 3.8 | 2541 | |
| 3.9 | 2527 |
| Value | Count | Frequency (%) |
| 5 | 6267 | |
| 4.9 | 12463 | |
| 4.8 | 6306 | |
| 4.7 | 6149 | |
| 4.6 | 12395 | |
| 4.5 | 6278 | |
| 4.4 | 5628 | |
| 4.3 | 11812 | |
| 4.2 | 11468 | |
| 4.1 | 5802 |
Payment Method
Categorical
Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 51280 |
| Missing (%) | 31.9% |
| Memory size | 9.7 MiB |
| UPI | |
|---|---|
| Cash | |
| Uber Wallet | |
| Credit Card | |
| Debit Card |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.5775046 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UPI |
|---|---|
| 2nd row | Debit Card |
| 3rd row | UPI |
| 4th row | UPI |
| 5th row | UPI |
Common Values
| Value | Count | Frequency (%) |
| UPI | 49223 | |
| Cash | 27176 | |
| Uber Wallet | 13151 | 8.2% |
| Credit Card | 10959 | 6.8% |
| Debit Card | 8820 | 5.5% |
| (Missing) | 51280 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| upi | 49223 | |
| cash | 27176 | |
| card | 19779 | |
| uber | 13151 | 9.2% |
| wallet | 13151 | 9.2% |
| credit | 10959 | 7.7% |
| debit | 8820 | 6.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 62374 | |
| a | 60106 | |
| C | 57914 | |
| P | 49223 | 8.1% |
| I | 49223 | 8.1% |
| e | 46081 | 7.6% |
| r | 43889 | 7.2% |
| 32930 | 5.4% | |
| t | 32930 | 5.4% |
| d | 30738 | 5.0% |
| Other values (7) | 144375 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 336148 | |
| Uppercase Letter | 240705 | |
| Space Separator | 32930 | 5.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 60106 | |
| e | 46081 | |
| r | 43889 | |
| t | 32930 | |
| d | 30738 | |
| h | 27176 | |
| s | 27176 | |
| l | 26302 | |
| b | 21971 | 6.5% |
| i | 19779 | 5.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 62374 | |
| C | 57914 | |
| P | 49223 | |
| I | 49223 | |
| W | 13151 | 5.5% |
| D | 8820 | 3.7% |
Space Separator
| Value | Count | Frequency (%) |
| 32930 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 576853 | |
| Common | 32930 | 5.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 62374 | |
| a | 60106 | |
| C | 57914 | |
| P | 49223 | |
| I | 49223 | |
| e | 46081 | 8.0% |
| r | 43889 | 7.6% |
| t | 32930 | 5.7% |
| d | 30738 | 5.3% |
| h | 27176 | 4.7% |
| Other values (6) | 117199 |
Common
| Value | Count | Frequency (%) |
| 32930 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 609783 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 62374 | |
| a | 60106 | |
| C | 57914 | |
| P | 49223 | 8.1% |
| I | 49223 | 8.1% |
| e | 46081 | 7.6% |
| r | 43889 | 7.2% |
| 32930 | 5.4% | |
| t | 32930 | 5.4% |
| d | 30738 | 5.0% |
| Other values (7) | 144375 |
Interactions
Correlations
| Avg CTAT | Avg VTAT | Booking Status | Booking Value | Customer Rating | Driver Cancellation Reason | Driver Ratings | Event | Incomplete Rides Reason | Payment Method | Reason for cancelling by Customer | Ride Distance | Vehicle Type | day | hour | month | weekday | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Avg CTAT | 1.000 | 0.058 | 0.471 | 0.000 | 0.001 | 0.000 | 0.001 | 0.004 | 0.000 | 0.000 | 0.000 | 0.101 | 0.001 | 0.000 | -0.001 | -0.001 | 0.005 |
| Avg VTAT | 0.058 | 1.000 | 0.338 | 0.005 | -0.003 | 0.000 | -0.005 | 0.004 | 0.000 | 0.000 | 0.014 | 0.063 | 0.000 | 0.004 | -0.005 | 0.003 | 0.003 |
| Booking Status | 0.471 | 0.338 | 1.000 | 0.006 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.353 | 0.003 | 0.000 | 0.000 | 0.001 | 0.004 |
| Booking Value | 0.000 | 0.005 | 0.006 | 1.000 | -0.004 | 0.000 | 0.001 | 0.017 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.008 | 0.001 | 0.000 | 0.108 |
| Customer Rating | 0.001 | -0.003 | 1.000 | -0.004 | 1.000 | 0.000 | -0.002 | 0.006 | 0.000 | 0.005 | 0.000 | 0.003 | 0.005 | -0.001 | -0.003 | -0.000 | 0.000 |
| Driver Cancellation Reason | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.010 | 0.009 | 0.009 | 0.007 |
| Driver Ratings | 0.001 | -0.005 | 1.000 | 0.001 | -0.002 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | -0.002 | 0.000 | -0.000 | 0.001 | -0.001 | 0.006 |
| Event | 0.004 | 0.004 | 0.000 | 0.017 | 0.006 | 0.000 | 0.000 | 1.000 | 0.018 | 0.000 | 0.015 | 0.004 | 0.000 | 0.233 | 0.000 | 0.477 | 0.156 |
| Incomplete Rides Reason | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.018 | 1.000 | 0.000 | 0.000 | 0.010 | 0.016 | 0.020 | 0.006 | 0.000 | 0.014 |
| Payment Method | 0.000 | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.005 | 0.006 | 0.006 | 0.003 | 0.006 | 0.004 |
| Reason for cancelling by Customer | 0.000 | 0.014 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.015 | 0.000 | 0.000 | 1.000 | 0.000 | 0.168 | 0.000 | 0.000 | 0.012 | 0.000 |
| Ride Distance | 0.101 | 0.063 | 0.353 | 0.004 | 0.003 | 0.000 | -0.002 | 0.004 | 0.010 | 0.005 | 0.000 | 1.000 | 0.000 | 0.006 | -0.002 | 0.005 | 0.000 |
| Vehicle Type | 0.001 | 0.000 | 0.003 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.016 | 0.006 | 0.168 | 0.000 | 1.000 | 0.003 | 0.004 | 0.003 | 0.003 |
| day | 0.000 | 0.004 | 0.000 | 0.008 | -0.001 | 0.010 | -0.000 | 0.233 | 0.020 | 0.006 | 0.000 | 0.006 | 0.003 | 1.000 | -0.003 | -0.019 | 0.069 |
| hour | -0.001 | -0.005 | 0.000 | 0.001 | -0.003 | 0.009 | 0.001 | 0.000 | 0.006 | 0.003 | 0.000 | -0.002 | 0.004 | -0.003 | 1.000 | 0.000 | 0.000 |
| month | -0.001 | 0.003 | 0.001 | 0.000 | -0.000 | 0.009 | -0.001 | 0.477 | 0.000 | 0.006 | 0.012 | 0.005 | 0.003 | -0.019 | 0.000 | 1.000 | 0.044 |
| weekday | 0.005 | 0.003 | 0.004 | 0.108 | 0.000 | 0.007 | 0.006 | 0.156 | 0.014 | 0.004 | 0.000 | 0.000 | 0.003 | 0.069 | 0.000 | 0.044 | 1.000 |
Missing values
Sample
| datetime | Date | Time | year | month | day | weekday | hour | ride_date | Event | Booking ID | Booking Status | Customer ID | Vehicle Type | Pickup Location | Drop Location | Ride Distance | Booking Value | Avg VTAT | Avg CTAT | Cancelled Rides by Customer | Reason for cancelling by Customer | Cancelled Rides by Driver | Driver Cancellation Reason | Incomplete Rides | Incomplete Rides Reason | Driver Ratings | Customer Rating | Payment Method | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-03-23 12:29:38 | 2024-03-23 | 12:29:38 | 2024 | 3 | 23 | Saturday | 12 | 2024-03-23 | Normal Day | "CNR5884300" | No Driver Found | "CID1982111" | eBike | Palam Vihar | Jhilmil | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 2024-11-29 18:01:39 | 2024-11-29 | 18:01:39 | 2024 | 11 | 29 | Friday | 18 | 2024-11-29 | Wedding_Season | "CNR1326809" | Incomplete | "CID4604802" | Go Sedan | Shastri Nagar | Gurgaon Sector 56 | 5.73 | 237.0 | 4.9 | 14.0 | NaN | NaN | NaN | NaN | 1.0 | Vehicle Breakdown | NaN | NaN | UPI |
| 2 | 2024-08-23 08:56:10 | 2024-08-23 | 08:56:10 | 2024 | 8 | 23 | Friday | 8 | 2024-08-23 | Monsoon | "CNR8494506" | Completed | "CID9202816" | Auto | Khandsa | Malviya Nagar | 13.58 | 627.0 | 13.4 | 25.8 | NaN | NaN | NaN | NaN | NaN | NaN | 4.9 | 4.9 | Debit Card |
| 3 | 2024-10-21 17:17:25 | 2024-10-21 | 17:17:25 | 2024 | 10 | 21 | Monday | 17 | 2024-10-21 | Normal Day | "CNR8906825" | Completed | "CID2610914" | Premier Sedan | Central Secretariat | Inderlok | 34.02 | 416.0 | 13.1 | 28.5 | NaN | NaN | NaN | NaN | NaN | NaN | 4.6 | 5.0 | UPI |
| 4 | 2024-09-16 22:08:00 | 2024-09-16 | 22:08:00 | 2024 | 9 | 16 | Monday | 22 | 2024-09-16 | Normal Day | "CNR1950162" | Completed | "CID9933542" | Bike | Ghitorni Village | Khan Market | 48.21 | 737.0 | 5.3 | 19.6 | NaN | NaN | NaN | NaN | NaN | NaN | 4.1 | 4.3 | UPI |
| 5 | 2024-02-06 09:44:56 | 2024-02-06 | 09:44:56 | 2024 | 2 | 6 | Tuesday | 9 | 2024-02-06 | Wedding_Season | "CNR4096693" | Completed | "CID4670564" | Auto | AIIMS | Narsinghpur | 4.85 | 316.0 | 5.1 | 18.1 | NaN | NaN | NaN | NaN | NaN | NaN | 4.1 | 4.6 | UPI |
| 6 | 2024-06-17 15:45:58 | 2024-06-17 | 15:45:58 | 2024 | 6 | 17 | Monday | 15 | 2024-06-17 | Eid-ul-Adha | "CNR2002539" | Completed | "CID6800553" | Go Mini | Vaishali | Punjabi Bagh | 41.24 | 640.0 | 7.1 | 20.4 | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 4.1 | UPI |
| 7 | 2024-03-19 17:37:37 | 2024-03-19 | 17:37:37 | 2024 | 3 | 19 | Tuesday | 17 | 2024-03-19 | Normal Day | "CNR6568000" | Completed | "CID8610436" | Auto | Mayur Vihar | Cyber Hub | 6.56 | 136.0 | 12.1 | 16.5 | NaN | NaN | NaN | NaN | NaN | NaN | 4.4 | 4.2 | UPI |
| 8 | 2024-09-14 12:49:09 | 2024-09-14 | 12:49:09 | 2024 | 9 | 14 | Saturday | 12 | 2024-09-14 | Monsoon | "CNR4510807" | No Driver Found | "CID7873618" | Go Sedan | Noida Sector 62 | Noida Sector 18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 2024-12-16 19:06:48 | 2024-12-16 | 19:06:48 | 2024 | 12 | 16 | Monday | 19 | 2024-12-16 | Normal Day | "CNR7721892" | Incomplete | "CID5214275" | Auto | Rohini | Adarsh Nagar | 10.36 | 135.0 | 6.1 | 26.0 | NaN | NaN | NaN | NaN | 1.0 | Other Issue | NaN | NaN | Cash |
| datetime | Date | Time | year | month | day | weekday | hour | ride_date | Event | Booking ID | Booking Status | Customer ID | Vehicle Type | Pickup Location | Drop Location | Ride Distance | Booking Value | Avg VTAT | Avg CTAT | Cancelled Rides by Customer | Reason for cancelling by Customer | Cancelled Rides by Driver | Driver Cancellation Reason | Incomplete Rides | Incomplete Rides Reason | Driver Ratings | Customer Rating | Payment Method | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 160599 | 2024-07-13 14:47:30 | 2024-07-13 | 14:47:30 | 2024 | 7 | 13 | Saturday | 14 | 2024-07-13 | Monsoon | "CNR5591053" | Completed | "CID1829616" | Auto | Karol Bagh | Vishwavidyalaya | 27.91 | 597.0 | 11.2 | 30.8 | NaN | NaN | NaN | NaN | NaN | NaN | 4.2 | 4.3 | UPI |
| 160600 | 2024-01-24 18:02:28 | 2024-01-24 | 18:02:28 | 2024 | 1 | 24 | Wednesday | 18 | 2024-01-24 | Normal Day | "CNR1717894" | No Driver Found | "CID9564749" | Go Mini | Nehru Place | Aya Nagar | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 160601 | 2024-05-03 11:18:17 | 2024-05-03 | 11:18:17 | 2024 | 5 | 3 | Friday | 11 | 2024-05-03 | Normal Day | "CNR9715958" | Completed | "CID8835432" | Go Mini | Tughlakabad | Jama Masjid | 29.89 | 280.0 | 13.2 | 20.1 | NaN | NaN | NaN | NaN | NaN | NaN | 4.1 | 4.7 | Cash |
| 160602 | 2024-06-14 16:46:53 | 2024-06-14 | 16:46:53 | 2024 | 6 | 14 | Friday | 16 | 2024-06-14 | Normal Day | "CNR9572383" | Completed | "CID2952237" | Go Mini | Akshardham | Greater Noida | 10.51 | 388.0 | 8.2 | 30.6 | NaN | NaN | NaN | NaN | NaN | NaN | 4.3 | 4.9 | UPI |
| 160603 | 2024-11-11 19:34:01 | 2024-11-11 | 19:34:01 | 2024 | 11 | 11 | Monday | 19 | 2024-11-11 | Wedding_Season | "CNR6500631" | Completed | "CID4337371" | Go Mini | MG Road | Ghitorni | 40.08 | 475.0 | 10.2 | 44.4 | NaN | NaN | NaN | NaN | NaN | NaN | 3.7 | 4.1 | Uber Wallet |
| 160604 | 2024-11-24 15:55:09 | 2024-11-24 | 15:55:09 | 2024 | 11 | 24 | Sunday | 15 | 2024-11-24 | Wedding_Season | "CNR2468611" | Completed | "CID2325623" | Go Mini | Golf Course Road | Akshardham | 21.31 | 1093.0 | 5.1 | 30.8 | NaN | NaN | NaN | NaN | NaN | NaN | 4.8 | 5.0 | UPI |
| 160605 | 2024-09-18 10:55:15 | 2024-09-18 | 10:55:15 | 2024 | 9 | 18 | Wednesday | 10 | 2024-09-18 | Normal Day | "CNR6358306" | Completed | "CID9925486" | Go Sedan | Satguru Ram Singh Marg | Jor Bagh | 15.93 | 852.0 | 2.7 | 23.4 | NaN | NaN | NaN | NaN | NaN | NaN | 3.9 | 4.4 | Cash |
| 160606 | 2024-10-05 07:53:34 | 2024-10-05 | 07:53:34 | 2024 | 10 | 5 | Saturday | 7 | 2024-10-05 | Navratri | "CNR3030099" | Completed | "CID9415487" | Auto | Ghaziabad | Saidulajab | 45.54 | 333.0 | 6.9 | 39.6 | NaN | NaN | NaN | NaN | NaN | NaN | 4.1 | 3.7 | UPI |
| 160607 | 2024-10-05 07:53:34 | 2024-10-05 | 07:53:34 | 2024 | 10 | 5 | Saturday | 7 | 2024-10-05 | Festive_Sales | "CNR3030099" | Completed | "CID9415487" | Auto | Ghaziabad | Saidulajab | 45.54 | 333.0 | 6.9 | 39.6 | NaN | NaN | NaN | NaN | NaN | NaN | 4.1 | 3.7 | UPI |
| 160608 | 2024-03-10 15:38:03 | 2024-03-10 | 15:38:03 | 2024 | 3 | 10 | Sunday | 15 | 2024-03-10 | Wedding_Season | "CNR3447390" | Completed | "CID4108667" | Premier Sedan | Ashok Park Main | Gurgaon Sector 29 | 21.19 | 806.0 | 3.5 | 33.7 | NaN | NaN | NaN | NaN | NaN | NaN | 4.6 | 4.9 | Credit Card |
Duplicate rows
Most frequently occurring
| datetime | Date | Time | year | month | day | weekday | hour | ride_date | Event | Booking ID | Booking Status | Customer ID | Vehicle Type | Pickup Location | Drop Location | Ride Distance | Booking Value | Avg VTAT | Avg CTAT | Cancelled Rides by Customer | Reason for cancelling by Customer | Cancelled Rides by Driver | Driver Cancellation Reason | Incomplete Rides | Incomplete Rides Reason | Driver Ratings | Customer Rating | Payment Method | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30 | 2024-01-13 09:16:53 | 2024-01-13 | 09:16:53 | 2024 | 1 | 13 | Saturday | 9 | 2024-01-13 | Normal Day | "CNR1665871" | Cancelled by Customer | "CID4830996" | Bike | Lal Quila | Vasant Kunj | NaN | NaN | 15.3 | NaN | 1.0 | Change of plans | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 |
| 31 | 2024-01-13 09:16:53 | 2024-01-13 | 09:16:53 | 2024 | 1 | 13 | Saturday | 9 | 2024-01-13 | Normal Day | "CNR3467484" | Cancelled by Customer | "CID1585469" | Uber XL | Sadar Bazar Gurgaon | Adarsh Nagar | NaN | NaN | 18.7 | NaN | 1.0 | Change of plans | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 |
| 32 | 2024-01-13 09:16:53 | 2024-01-13 | 09:16:53 | 2024 | 1 | 13 | Saturday | 9 | 2024-01-13 | Normal Day | "CNR5995469" | Completed | "CID1368457" | eBike | Malviya Nagar | Hero Honda Chowk | 7.66 | 445.0 | 5.8 | 22.4 | NaN | NaN | NaN | NaN | NaN | NaN | 4.6 | 4.7 | Credit Card | 3 |
| 0 | 2024-01-01 21:54:16 | 2024-01-01 | 21:54:16 | 2024 | 1 | 1 | Monday | 21 | 2024-01-01 | New Year | "CNR9901275" | Completed | "CID9869633" | Go Sedan | Vatika Chowk | Inderlok | 4.61 | 202.0 | 2.3 | 40.1 | NaN | NaN | NaN | NaN | NaN | NaN | 4.7 | 4.2 | Cash | 2 |
| 1 | 2024-01-01 21:54:16 | 2024-01-01 | 21:54:16 | 2024 | 1 | 1 | Monday | 21 | 2024-01-01 | New Year | "CNR9918929" | Completed | "CID7591176" | Premier Sedan | Palam Vihar | Shastri Park | 14.89 | 349.0 | 7.1 | 30.7 | NaN | NaN | NaN | NaN | NaN | NaN | 4.1 | 4.0 | UPI | 2 |
| 2 | 2024-01-02 17:16:29 | 2024-01-02 | 17:16:29 | 2024 | 1 | 2 | Tuesday | 17 | 2024-01-02 | Normal Day | "CNR5455862" | Cancelled by Driver | "CID3909649" | Go Sedan | Akshardham | Malviya Nagar | NaN | NaN | 7.6 | NaN | NaN | NaN | 1.0 | Personal & Car related issues | NaN | NaN | NaN | NaN | NaN | 2 |
| 3 | 2024-01-02 17:16:29 | 2024-01-02 | 17:16:29 | 2024 | 1 | 2 | Tuesday | 17 | 2024-01-02 | Normal Day | "CNR9650422" | Completed | "CID4731274" | Go Mini | Old Gurgaon | Moti Nagar | 34.06 | 1917.0 | 10.1 | 19.0 | NaN | NaN | NaN | NaN | NaN | NaN | 4.6 | 4.9 | UPI | 2 |
| 4 | 2024-01-02 17:57:47 | 2024-01-02 | 17:57:47 | 2024 | 1 | 2 | Tuesday | 17 | 2024-01-02 | Normal Day | "CNR8346445" | Completed | "CID9173008" | Bike | Pitampura | Vishwavidyalaya | 46.67 | 160.0 | 2.1 | 17.6 | NaN | NaN | NaN | NaN | NaN | NaN | 4.2 | 4.2 | UPI | 2 |
| 5 | 2024-01-02 17:57:47 | 2024-01-02 | 17:57:47 | 2024 | 1 | 2 | Tuesday | 17 | 2024-01-02 | Normal Day | "CNR8949149" | Completed | "CID8694169" | Go Sedan | Barakhamba Road | Dwarka Mor | 42.66 | 919.0 | 10.2 | 26.3 | NaN | NaN | NaN | NaN | NaN | NaN | 4.2 | 4.1 | UPI | 2 |
| 6 | 2024-01-03 09:36:43 | 2024-01-03 | 09:36:43 | 2024 | 1 | 3 | Wednesday | 9 | 2024-01-03 | Normal Day | "CNR5832024" | Cancelled by Driver | "CID8105586" | Auto | ITO | INA Market | NaN | NaN | 7.2 | NaN | NaN | NaN | 1.0 | More than permitted people in there | NaN | NaN | NaN | NaN | NaN | 2 |